<!-- index.html -->
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>test</title>
    <script type="text/javascript">
        var db = openDatabase('mydb','1.0','Test DB',2 * 1024 * 1024);
        var msg;
        db.transaction(function(tx){
          tx.executeSql('INSERT INTO LOGS (id,log) VALUES(1,"test1")');
          tx.executeSql('INSERT INTO LOGS (id,log) VALUES(2,"test2")');
          msg = '<p>数据表已创建,且插入了两条数据。</p>';
          document.querySelector('#status').innerHTML = msg;
        });
        db.transaction(function(tx){
          tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) {
            var len = results.rows.length,i;
            msg = "<p>查询记录条数：" + len + "</p>";
            document.querySelector('#status').innerHTML += msg;
                for(i = 0; i < len; i++){
                  msg = "<p><b>" + results.rows.item(i).log + "</b></p>";
            document.querySelector('#status').innerHTML += msg;
            }
          },null);
        });
    </script>
</head>
<body>
<div id="status" name="status">状态信息</div>
</body>
</html>